﻿<%@ Page Title="Commodity Information Page" Language="C#" MasterPageFile="~/Home.Master" AutoEventWireup="true" CodeBehind="frmCommodity.aspx.cs" Inherits="DomesticPestProject.frmCommodity" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder6" runat="server">
         <table style="width: 180px">
         <tr>
         <td>
         &nbsp;&nbsp;<asp:Button ID="btnCommodity" runat="server" Text="Commodity" 
                  Width="140px" Font-Bold="True" ForeColor="Black" onclick="btnCommodity_Click" 
                  />
         </td>
         </tr>
         <tr><td></td></tr>
         <tr>
         <td>
         
         &nbsp;&nbsp;<asp:Button ID="btnInformation" runat="server" Text="Information" 
                 Width="140px" Font-Bold="True" ForeColor="#000066" onclick="btnInformation_Click" 
                 />
         </td>
         </tr>
         <tr><td></td></tr>
         <tr>
         <td>
         &nbsp;&nbsp;<asp:Button ID="btnTransaction" runat="server" Text="Transaction" 
                 Width="139px" Font-Bold="True" ForeColor="#000066" 
                 onclick="btnTransaction_Click" />
         
         </td>
         </tr>
         <tr><td></td></tr>
         <tr>
         <td>
          &nbsp;&nbsp;<asp:Button ID="btnPest" runat="server" Text="Pest" Width="140px" 
                 Font-Bold="True" ForeColor="#000066" onclick="btnPest_Click" 
                 />
         
         </td>
         </tr>
         <tr><td></td></tr>
         <tr>
         <td>
         &nbsp;&nbsp;<asp:Button ID="btnLctn" runat="server" Text="Location" Width="138px" 
                 Font-Bold="True" ForeColor="#000066" onclick="btnLctn_Click" />
                
         </td>
         </tr>
         <tr><td></td></tr>
         <tr>
         <td>
         
         &nbsp;&nbsp;<asp:Button ID="btnPsDsrbtn" runat="server" Text="Pest Distribution" 
                 Width="138px" Font-Bold="True" ForeColor="#000066" 
                 onclick="btnPsDsrbtn_Click" />
         </td>
         
         </tr>
         <tr><td></td></tr>
         <tr>
         <td>
         
         &nbsp;&nbsp;<asp:Button ID="btnMain" runat="server" Text="Main Page" 
                 Width="138px" Font-Bold="True" ForeColor="#000066" 
                 onclick="btnMain_Click" />
         </td>
         
         </tr>
         </table>
         </asp:Content>
<asp:Content ID="Content7" ContentPlaceHolderID="ContentPlaceHolder7" runat="server">
    &nbsp;
<table>
<tr>
        <td>
            &nbsp;&nbsp;<asp:Label ID="lblByrCd" runat="server" Text="Bayers Code :"></asp:Label>
        </td>
        <td>
             &nbsp;&nbsp;<asp:TextBox ID="txtByrCd" runat="server" Height="16px" 
                 Width="154px" style="margin-left: 17px"></asp:TextBox>
        </td>
    </tr>
</table>

    <asp:Panel ID="pnlshow" runat="server">
   <table>
    
    <tr>
        <td>
            &nbsp;&nbsp;<asp:Label ID="lblCtgy" runat="server" Text="Category :"></asp:Label>
        </td>
        <td>
             &nbsp;&nbsp;<asp:DropDownList ID="ddlCtgy" runat="server" Height="16px" 
                 Width="154px" AutoPostBack="True" DataSourceID="SqlDataSource1" 
                 DataTextField="Category" DataValueField="Category">
             </asp:DropDownList>
             <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                 ConnectionString="<%$ ConnectionStrings:DomesticPestDBConnectionString %>" 
                 SelectCommand="SELECT [CATEGORY] FROM [Commodity]"></asp:SqlDataSource>
        </td>

    </tr>
    <tr>
        <td>
              &nbsp;&nbsp;<asp:Label ID="lblCmnNm" runat="server" Text="Common Name :"></asp:Label>
        </td>
        <td>
              &nbsp;&nbsp;<asp:TextBox ID="txtCmnNm" runat="server" Height="16px" Width="154px"></asp:TextBox>
        </td>
    </tr>
    <tr>
        <td>
             &nbsp;&nbsp;<asp:Label ID="lblSctfcNm" runat="server" Text="Scientific Name :"></asp:Label>
        </td>
        <td>
             &nbsp;&nbsp;<asp:TextBox ID="txtSctfcNm" runat="server" Height="16px" Width="154px"></asp:TextBox>
        </td>
    </tr>
    <tr>
        <td>
           &nbsp;&nbsp;<asp:Label ID="lblSynm" runat="server" Text="Synonym :"></asp:Label>
        </td>
        <td>
           &nbsp;&nbsp;<asp:TextBox ID="txtSynm" runat="server" Height="16px" Width="154px"></asp:TextBox>
        </td>
    </tr>
    <tr>
        <td>
            &nbsp;&nbsp;<asp:Label ID="lblSbSpcs" runat="server" Text="Sub Species :"></asp:Label>
        </td>
        <td>
             &nbsp;&nbsp;<asp:DropDownList ID="ddlSbSpcs" runat="server" Height="16px" 
                 Width="154px" DataSourceID="SqlDataSource2" DataTextField="SYNONYM" 
                 DataValueField="SYNONYM">
             </asp:DropDownList>
             <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
                 ConnectionString="<%$ ConnectionStrings:DomesticPestDBConnectionString %>" 
                 SelectCommand="SELECT [SYNONYM] FROM [Commodity]"></asp:SqlDataSource>
        </td>

    </tr>
    <tr>
        <td>
           &nbsp;&nbsp;<asp:Label ID="lblFmlyNm" runat="server" Text="Family Name :"></asp:Label>
        </td>
        <td>
            &nbsp;&nbsp;<asp:DropDownList ID="ddlFmlyNm" runat="server" Height="16px" 
                Width="154px" DataSourceID="SqlDataSource3" DataTextField="ORDER" 
                DataValueField="ORDER">
             </asp:DropDownList>
            <asp:SqlDataSource ID="SqlDataSource3" runat="server" 
                ConnectionString="<%$ ConnectionStrings:DomesticPestDBConnectionString %>" 
                SelectCommand="SELECT [ORDER] FROM [Commodity]"></asp:SqlDataSource>
        </td>

    </tr>
    <tr>
        <td>
           &nbsp;&nbsp;<asp:Label ID="lblOdrNm" runat="server" Text="Order Name :"></asp:Label>
        </td>
        <td>
           &nbsp;&nbsp;<asp:TextBox ID="txtOdrNm" runat="server" Height="16px" 
                Width="154px"></asp:TextBox>
        </td>
        </tr>
    <tr>
    <td></td>
    </tr>
   
</table>
    </asp:Panel>

    <asp:Panel ID="pnlAdd" runat="server">
   <table>
    
    <tr>
        <td>
            &nbsp;&nbsp;<asp:Label ID="Label1" runat="server" Text="Category :"></asp:Label>
        </td>
        
          <td>
              &nbsp;&nbsp;<asp:TextBox ID="txtAddCategory" runat="server" Height="16px" Width="154px"></asp:TextBox>
          </td>

    </tr>
    <tr>
        <td>
              &nbsp;&nbsp;<asp:Label ID="Label2" runat="server" Text="Common Name :"></asp:Label>
        </td>
        <td>
              &nbsp;&nbsp;<asp:TextBox ID="txtAddCommonNm" runat="server" Height="16px" Width="154px"></asp:TextBox>
        </td>
    </tr>
    <tr>
        <td>
             &nbsp;&nbsp;<asp:Label ID="Label3" runat="server" Text="Scientific Name :"></asp:Label>
        </td>
        <td>
             &nbsp;&nbsp;<asp:TextBox ID="txtAddSciName" runat="server" Height="16px" Width="154px"></asp:TextBox>
        </td>
    </tr>
    <tr>
        <td>
           &nbsp;&nbsp;<asp:Label ID="Label4" runat="server" Text="Synonym :"></asp:Label>
        </td>
        <td>
           &nbsp;&nbsp;<asp:TextBox ID="txtAddSynonym" runat="server" Height="16px" Width="154px"></asp:TextBox>
        </td>
    </tr>
    <tr>
        <td>
            &nbsp;&nbsp;<asp:Label ID="Label5" runat="server" Text="Sub Species :"></asp:Label>
        </td>
        <td>
           &nbsp;&nbsp;<asp:TextBox ID="txtAddSubSpc" runat="server" Height="16px" Width="154px"></asp:TextBox>
        </td>

    </tr>
    <tr>
        <td>
           &nbsp;&nbsp;<asp:Label ID="Label6" runat="server" Text="Family Name :"></asp:Label>
        </td>
        <td>
           &nbsp;&nbsp;<asp:TextBox ID="txtAddFNm" runat="server" Height="16px" Width="154px"></asp:TextBox>
        </td>

    </tr>
    <tr>
        <td>
           &nbsp;&nbsp;<asp:Label ID="Label7" runat="server" Text="Order Name :"></asp:Label>
        </td>
        <td>
           &nbsp;&nbsp;<asp:TextBox ID="txtAddOrderNm" runat="server" Height="16px" Width="154px"></asp:TextBox>
        </td>
    </tr>
    <tr>
    <td></td>
    </tr>
   
</table>
    </asp:Panel>
    
<table>
 <tr>
    <td>
        <asp:Button ID="btnAdd" runat="server" Text="Add" Height="27px" 
            onclick="btnAdd_Click" />
    </td>
    <td>
        <asp:Button ID="btnModify" runat="server" Text="Modify" Enabled="False" />
    </td>
    <td>
        <asp:Button ID="btnDelete" runat="server" Text="Delete" Enabled="False" />
    </td>
    <td>
        <asp:Button ID="btnListing" runat="server" Text="Listing" Enabled="False" />
    </td>
    <td>
        <asp:Button ID="btnSave" runat="server" Text="Save" Enabled="False" 
            onclick="btnSave_Click" />
    </td>
    <td>
        <asp:Button ID="btnCancel" runat="server" Text="Cancel" Enabled="False" 
            onclick="btnCancel_Click" />
    </td>
    <td>
       <asp:Button ID="btnExit" runat="server" Text="Exit" />
    </td>
    </tr>
</table>

<p></p>
    <asp:Panel ID="Panel1" runat="server">
        <asp:GridView ID="gvComm" runat="server" BackColor="White" BorderColor="White" 
            BorderStyle="Ridge" BorderWidth="2px" CellPadding="3" CellSpacing="1" 
            ForeColor="#003366" GridLines="None" 
            onrowcancelingedit="gvComm_RowCancelingEdit" onrowediting="gvComm_RowEditing" 
            onrowupdating="gvComm_RowUpdating" ShowHeaderWhenEmpty="True" Width="673px" 
            onrowdeleting="gvComm_RowDeleting" AllowPaging="True">
            <Columns>
                <asp:CommandField HeaderText="Delete" ShowDeleteButton="True" 
                    ShowHeader="True" />
                <asp:CommandField HeaderText="Edit" ShowEditButton="True" ShowHeader="True" />
            </Columns>
            <FooterStyle BackColor="#C6C3C6" ForeColor="Black" />
            <HeaderStyle BackColor="#003366" Font-Bold="True" ForeColor="#97CBFF" />
            <PagerStyle BackColor="#B3D9FF" ForeColor="#003366" HorizontalAlign="Right" />
            <RowStyle BackColor="#BFBFFF" ForeColor="#003366" />
            <SelectedRowStyle BackColor="#000066" Font-Bold="True" ForeColor="White" />
            <SortedAscendingCellStyle BackColor="#F1F1F1" />
            <SortedAscendingHeaderStyle BackColor="#594B9C" />
            <SortedDescendingCellStyle BackColor="#CAC9C9" />
            <SortedDescendingHeaderStyle BackColor="#000066" />
        </asp:GridView>
    </asp:Panel>
</asp:Content>
<asp:Content ID="Content8" runat="server" 
    contentplaceholderid="ContentPlaceHolder1">
</asp:Content>

